2017-05-19 - 35060 - Break Fix - Sales Analysis in Explorer #BExQueriesforCrystalReportsAnalysisTool
BREAK FIX
35060 - Sales Analysis in Explorer
Problem Summary
Need to modify the shipped cost formula in BEx queries and update the Sales Analysis Explorer spaces.
Admin Info
Purpose
|
Need to modify the shipped cost formula in BEx queries and update the Sales Analysis Explorer spaces.
|
Requested by
|
Mark Harris
|
Issue Date
|
05/19/2017
|
Resolved by
|
Naveen/Dhananjay G
|
Resolved Date
|
05/26/2017
|
Document Status
|
Complete
|
Detailed Problem Description
Shipped cost data is not getting validated between Analysis Query VBPC_MP_Q001 & Explorer for Sales Analysis.
Solution Analysis and Recommendations
The formulas for shipped cost are different in Analysis Query VBPC_MP_Q001 & Query used by Sales Analysis Explorers ZBPC_MP_Q020, ZJA_BPC_Q020 and ZEM_BPC_Q020.
In Query used by Sales Analysis Explorer
TY Shipped = Manual CoGS(Z_MANADJ) + (Z_STCKVAL)Shipped cost.
In Analysis Query
TY Shipped = Z_STCKVAL
Now the request is to view the shipped cost alone in Queries used by Explorers(ZBPC_MP_Q020, ZJA_BPC_Q020 & ZEM_BPC_Q020).
Resolution
By replacing Manual CoGS + Shipped Cost to only shipped cost in Queries used by Explorers(ZBPC_MP_Q020, ZJA_BPC_Q020 & ZEM_BPC_Q020) resolved the issue.
Release Information
2017-05-19 - 35060 - Rel Notes - Sales Analysis in Explorer